<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<?php @session_start();
if(!isset($_SESSION['email'])){ die();}
@include"sql.php";
$email=$_SESSION['email'];
$query2="select score from login where email=\"$email\";";
$result2=mysql_query($query2);
if (!mysql_query($query2))
  {
  die('Error: ' . mysql_error());
  } 
$row2 = mysql_fetch_array($result2);
$score=$row2[0];
$query="select name,score from login where score>$score order by score ASC;";
$result=mysql_query($query);
$row = mysql_fetch_array($result);
$quer="select email from login where score=(select max(score) from login);";
$res2=mysql_query($quer);
$rw=mysql_fetch_array($res2);
if( strcasecmp("$rw[0]","$email")==0 ){ echo "you are currently leading with scrore= $score";}
else{echo" The Player imidiatly Ahead of you is $row[0] with score=$row[1]";}
?>


<body>
</body>
</html>
